PTD Billing
The PTD Billing report shows period to date (PTD) billed WIP. You can monitor billed WIP by category, subcategory, and service code, and adjust the level of detail to include.
Permissions Required for this Report
In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:
- Security group profile > Functional rights > Reports > Shared Library > Shared Views
- Security group profile > Functional rights > Reports > Firm Library > Custom
- Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
- Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
- Security group profile > Functional rights > Reports > Firm Library > <report name>
- Security group profile > Functional rights > Administration Manager > Client Manager > Approved Clients
Reports in Foundation that are Comparable
In Practice Management, the comparable report is PTD Billing. In Practice Advantage, the comparable report is Billing Review.
Report Specifications
The following report options and filters are available to determine the report contents.
Options and Settings | ||
---|---|---|
Option | Setting | Description |
Hide Details |
Yes/No |
Includes or excludes details of each transaction. If hidden, select to subtotal your groups to view the amounts for each selected grouping. |
Use Expense in Realization Percentage |
Yes/No |
Includes or excludes the expense transactions in the realization calculation. |
Use Expense in Effective Rate |
Yes/No |
Includes or excludes the expense transactions in the effective rate calculation. |
Hide Comma |
Yes/No |
Includes or excludes commas in numbers. |
Hide Pennies |
Yes/No |
Includes or excludes pennies in the amounts. |
Include Deleted Clients |
Yes/No |
Includes or excludes deleted client information |
Default Filters | ||
---|---|---|
Field Name | Operator | Value |
Invoice Date | Between | First Day of Current Fiscal Year, Today |
Optional Filters | ||
---|---|---|
Available Fields | ||
Accounting Period Date |
Client Name |
Invoice Amount |
Business Code |
Client Office |
Invoice Date |
Category |
Client Primary Service Type |
Invoice Number |
Client |
Client Region |
Line of Business |
Client – Principal |
Client Sub ID |
Manager |
Client Bill Manager |
Client Type |
Posted Date |
Client Billing Group |
Effective Rate |
Primary Partner |
Client Business Unit |
Expenses |
Real% |
Client ID |
Financial Reporting Client Group |
Return Group |
Client ID.Sub ID |
Hours |
Service Code |
Subcategory |
Tax Type |
Write Up/Down |
Grouping | ||
---|---|---|
Available Fields | ||
Business Code |
Client Name |
Manager |
Category |
Client Office |
Primary Partner |
Client |
Client Primary Service Type |
Return Group |
Client – Principal |
Client Region |
Service Code |
Client Bill Manager |
Client Sub ID |
Sort Name |
Client Billing Group |
Client Type |
Subcategory |
Client Business Unit |
Financial Reporting Client Group |
Tax Type |
Client ID |
Invoice Date |
|
Client ID.Sub ID |
Line of Business |
|
Sorting | ||
---|---|---|
Available Fields | ||
Category |
Invoice Amount |
Service Code |
Effective Rate |
Invoice Date |
Subcategory |
Expenses |
Invoice Number |
Write Up/Down |
Hours |
Real % |
|
Report Fields
The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.
Report Fields | |
---|---|
Field | Description |
Category |
The category ID the service code is assigned to. |
Subcategory |
The subcategory ID the service code is assigned to. |
Service Code |
The transaction service code in Service Code Name (Service Code ID) format. |
Invoice Date |
The transaction invoice date. |
Invoice Number |
The number that is assigned to the invoice. |
Invoice Amount |
The amount of the invoice. The calculation is billed WIP +/- write up/down. |
Write Up/Down |
The total write up/down for the invoice. |
Real % |
The transaction realization percentage. The calculation is billed amount + write up/down divided by billed amounts, excluding expenses (unless you selected to include expenses). |
Effective Rate |
The effective rate for that transaction. The calculation is billed amount + write up/down divided by billed hours, excluding expenses (unless you selected to include expenses). |
Expenses |
The total expenses billed on the invoice without write up/down. |
Hours |
The total number of hours included on the invoice. |
PTD Billing Sample Report